/*
 Navicat Premium Data Transfer

 Source Server         : database
 Source Server Type    : MySQL
 Source Server Version : 50728 (5.7.28)
 Source Host           : localhost:3306
 Source Schema         : tinyshop

 Target Server Type    : MySQL
 Target Server Version : 50728 (5.7.28)
 File Encoding         : 65001

 Date: 14/06/2024 21:01:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for good
-- ----------------------------
DROP TABLE IF EXISTS `good`;
CREATE TABLE `good` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `content` text,
  `pic_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `merchant_id` int(11) DEFAULT NULL,
  `status` int(3) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `sales` int(11) DEFAULT '0',
  `sale_price` decimal(10,2) DEFAULT NULL,
  `market_price` decimal(10,2) DEFAULT NULL,
  `tags` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of good
-- ----------------------------
BEGIN;
INSERT INTO `good` (`id`, `name`, `description`, `content`, `pic_id`, `category_id`, `merchant_id`, `status`, `created_at`, `updated_at`, `sales`, `sale_price`, `market_price`, `tags`) VALUES (18, '华为Mate60Pro', NULL, NULL, 114, 46, 2, 1, '2024-06-12 21:44:26', '2024-06-12 21:44:26', 0, 20.00, 50.00, NULL);
INSERT INTO `good` (`id`, `name`, `description`, `content`, `pic_id`, `category_id`, `merchant_id`, `status`, `created_at`, `updated_at`, `sales`, `sale_price`, `market_price`, `tags`) VALUES (19, '华为Mate60Pro', NULL, NULL, 115, 47, 2, 1, '2024-06-12 23:16:54', '2024-06-12 23:16:54', 0, 30.00, 190.00, NULL);
COMMIT;

-- ----------------------------
-- Table structure for good_category
-- ----------------------------
DROP TABLE IF EXISTS `good_category`;
CREATE TABLE `good_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `merchant_id` int(11) DEFAULT NULL,
  `status` int(3) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of good_category
-- ----------------------------
BEGIN;
INSERT INTO `good_category` (`id`, `name`, `description`, `image_id`, `parent_id`, `merchant_id`, `status`, `created_at`, `updated_at`) VALUES (46, '手机', '手机', 114, NULL, 1, 1, '2024-06-12 22:59:02', '2024-06-12 22:59:02');
INSERT INTO `good_category` (`id`, `name`, `description`, `image_id`, `parent_id`, `merchant_id`, `status`, `created_at`, `updated_at`) VALUES (47, '华为', NULL, 124, 46, 1, 1, '2024-06-12 22:57:24', '2024-06-12 22:57:24');
COMMIT;

-- ----------------------------
-- Table structure for good_image
-- ----------------------------
DROP TABLE IF EXISTS `good_image`;
CREATE TABLE `good_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_id` int(11) DEFAULT NULL,
  `good_id` int(11) DEFAULT NULL,
  `merchant_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of good_image
-- ----------------------------
BEGIN;
INSERT INTO `good_image` (`id`, `file_id`, `good_id`, `merchant_id`, `created_at`, `updated_at`) VALUES (21, 114, 19, NULL, '2024-06-12 21:44:26', '2024-06-12 21:44:26');
INSERT INTO `good_image` (`id`, `file_id`, `good_id`, `merchant_id`, `created_at`, `updated_at`) VALUES (22, 115, 19, NULL, '2024-06-12 21:44:26', '2024-06-12 21:44:26');
INSERT INTO `good_image` (`id`, `file_id`, `good_id`, `merchant_id`, `created_at`, `updated_at`) VALUES (23, 116, 19, NULL, NULL, NULL);
INSERT INTO `good_image` (`id`, `file_id`, `good_id`, `merchant_id`, `created_at`, `updated_at`) VALUES (24, 117, 19, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for good_order
-- ----------------------------
DROP TABLE IF EXISTS `good_order`;
CREATE TABLE `good_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(100) DEFAULT NULL,
  `status` enum('ordered','inpayment','paid','receiving','completed','canceled') NOT NULL DEFAULT 'ordered',
  `address_id` int(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `link_man` varchar(255) DEFAULT NULL,
  `link_phone` varchar(255) DEFAULT NULL,
  `goods_total_qty` int(11) DEFAULT NULL,
  `total_amount` decimal(10,2) DEFAULT NULL,
  `merchant_id` int(11) DEFAULT NULL,
  `shop_name` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of good_order
-- ----------------------------
BEGIN;
INSERT INTO `good_order` (`id`, `order_no`, `status`, `address_id`, `address`, `link_man`, `link_phone`, `goods_total_qty`, `total_amount`, `merchant_id`, `shop_name`, `remark`, `user_name`, `user_id`, `created_at`, `updated_at`) VALUES (1, '1718368218601010', 'paid', 1, '北京市北京市东城区八维', '斌', '18312341234', 1, 60.30, 1, '华为官方', '', 'bin', 3, '2024-06-14 20:30:18', '2024-06-14 20:30:26');
COMMIT;

-- ----------------------------
-- Table structure for good_order_line
-- ----------------------------
DROP TABLE IF EXISTS `good_order_line`;
CREATE TABLE `good_order_line` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `good_id` int(11) DEFAULT NULL,
  `good_name` varchar(255) DEFAULT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `market_price` decimal(10,2) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `good_pic` varchar(255) DEFAULT NULL,
  `good_spec_id` int(11) DEFAULT NULL,
  `good_spec_name` varchar(255) DEFAULT NULL,
  `good_category_name` varchar(255) DEFAULT NULL,
  `good_category_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of good_order_line
-- ----------------------------
BEGIN;
INSERT INTO `good_order_line` (`id`, `good_id`, `good_name`, `sale_price`, `market_price`, `qty`, `amount`, `order_id`, `good_pic`, `good_spec_id`, `good_spec_name`, `good_category_name`, `good_category_id`, `created_at`, `updated_at`) VALUES (1, 19, '华为Mate60Pro', 20.10, 50.00, 3, 60.30, 1, '/public/uploads/2024/06/12/1718199895732150.9327417864763.jpeg', NULL, NULL, '华为', 47, '2024-06-14 20:30:18', '2024-06-14 20:30:18');
COMMIT;

-- ----------------------------
-- Table structure for good_spec
-- ----------------------------
DROP TABLE IF EXISTS `good_spec`;
CREATE TABLE `good_spec` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `pic` varchar(255) DEFAULT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `market_price` decimal(10,2) DEFAULT NULL,
  `sales` int(11) DEFAULT '0',
  `stock` int(9) DEFAULT NULL,
  `good_id` int(11) DEFAULT NULL,
  `merchant_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of good_spec
-- ----------------------------
BEGIN;
INSERT INTO `good_spec` (`id`, `name`, `description`, `pic`, `sale_price`, `market_price`, `sales`, `stock`, `good_id`, `merchant_id`, `created_at`, `updated_at`) VALUES (11, '白色的', NULL, '/public/uploads/2024/06/12/1718207162872869.3411692471924.jpeg', 20.10, 50.00, 0, 999, 19, 1, '2024-06-12 21:44:26', '2024-06-12 21:44:26');
COMMIT;

-- ----------------------------
-- Table structure for log_message
-- ----------------------------
DROP TABLE IF EXISTS `log_message`;
CREATE TABLE `log_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `sender` int(11) DEFAULT NULL,
  `receiver` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of log_message
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for merchant
-- ----------------------------
DROP TABLE IF EXISTS `merchant`;
CREATE TABLE `merchant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `app_id` varchar(50) DEFAULT NULL,
  `app_secret` varchar(255) DEFAULT NULL,
  `mch_id` varchar(50) DEFAULT NULL,
  `mch_key` varchar(255) DEFAULT NULL,
  `user_id` int(9) DEFAULT NULL,
  `status` int(3) DEFAULT NULL,
  `logo_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of merchant
-- ----------------------------
BEGIN;
INSERT INTO `merchant` (`id`, `name`, `address`, `app_id`, `app_secret`, `mch_id`, `mch_key`, `user_id`, `status`, `logo_id`, `created_at`, `updated_at`) VALUES (1, '华为官方', NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '2024-06-12 22:02:13', '2024-06-12 22:02:13');
INSERT INTO `merchant` (`id`, `name`, `address`, `app_id`, `app_secret`, `mch_id`, `mch_key`, `user_id`, `status`, `logo_id`, `created_at`, `updated_at`) VALUES (2, '华为官方', NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '2024-06-12 22:02:13', '2024-06-12 22:02:13');
COMMIT;

-- ----------------------------
-- Table structure for shop_banner
-- ----------------------------
DROP TABLE IF EXISTS `shop_banner`;
CREATE TABLE `shop_banner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `merchant_id` int(11) NOT NULL,
  `status` int(11) DEFAULT '1',
  `image_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of shop_banner
-- ----------------------------
BEGIN;
INSERT INTO `shop_banner` (`id`, `url`, `sort`, `merchant_id`, `status`, `image_id`, `created_at`, `updated_at`) VALUES (9, 'http://www.baidu.com', 1, 2, 1, 123, '2024-06-12 22:44:51', '2024-06-12 22:44:51');
INSERT INTO `shop_banner` (`id`, `url`, `sort`, `merchant_id`, `status`, `image_id`, `created_at`, `updated_at`) VALUES (10, 'http://www.jd.com', 2, 2, 1, 125, '2024-06-12 23:46:14', '2024-06-12 23:46:14');
COMMIT;

-- ----------------------------
-- Table structure for system_file
-- ----------------------------
DROP TABLE IF EXISTS `system_file`;
CREATE TABLE `system_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `format` varchar(50) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `size` double DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_file
-- ----------------------------
BEGIN;
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (114, 'image/jpeg', '/public/uploads/2024/06/12/1718199612676660.8201192799442.jpeg', 'app/public/uploads/2024/06/12/1718199612676660.8201192799442.jpeg', 'image', 513927, '1718199612676660.8201192799442.jpeg', '1', '2024-06-12 21:40:12', '2024-06-12 21:40:12');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (115, 'image/jpeg', '/public/uploads/2024/06/12/1718199895732150.9327417864763.jpeg', 'app/public/uploads/2024/06/12/1718199895732150.9327417864763.jpeg', 'image', 181548, '1718199895732150.9327417864763.jpeg', '1', '2024-06-12 21:44:55', '2024-06-12 21:44:55');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (116, 'image/jpeg', '/public/uploads/2024/06/12/1718199933562213.0770602093639.jpeg', 'app/public/uploads/2024/06/12/1718199933562213.0770602093639.jpeg', 'image', 181548, '1718199933562213.0770602093639.jpeg', '1', '2024-06-12 21:45:33', '2024-06-12 21:45:33');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (117, 'image/jpeg', '/public/uploads/2024/06/12/1718201135233497.46181515563757.jpeg', 'app/public/uploads/2024/06/12/1718201135233497.46181515563757.jpeg', 'image', 181548, '1718201135233497.46181515563757.jpeg', '1', '2024-06-12 22:05:35', '2024-06-12 22:05:35');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (118, 'image/jpeg', '/public/uploads/2024/06/12/1718201711236469.3674641575205.jpeg', 'app/public/uploads/2024/06/12/1718201711236469.3674641575205.jpeg', 'image', 181548, '1718201711236469.3674641575205.jpeg', '2', '2024-06-12 22:15:11', '2024-06-12 22:15:11');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (119, 'image/jpeg', '/public/uploads/2024/06/12/1718201894946692.4105004065971.jpeg', 'app/public/uploads/2024/06/12/1718201894946692.4105004065971.jpeg', 'image', 181548, '1718201894946692.4105004065971.jpeg', '1', '2024-06-12 22:18:14', '2024-06-12 22:18:14');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (120, 'image/jpeg', '/public/uploads/2024/06/12/1718201953888480.1939369722146.jpeg', 'app/public/uploads/2024/06/12/1718201953888480.1939369722146.jpeg', 'image', 181548, '1718201953888480.1939369722146.jpeg', '1', '2024-06-12 22:19:13', '2024-06-12 22:19:13');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (121, 'image/jpeg', '/public/uploads/2024/06/12/1718202789074778.028559457661.jpeg', 'app/public/uploads/2024/06/12/1718202789074778.028559457661.jpeg', 'image', 181548, '1718202789074778.028559457661.jpeg', '1', '2024-06-12 22:33:09', '2024-06-12 22:33:09');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (122, 'image/jpeg', '/public/uploads/2024/06/12/1718203293110810.4415433449666.jpeg', 'app/public/uploads/2024/06/12/1718203293110810.4415433449666.jpeg', 'image', 181548, '1718203293110810.4415433449666.jpeg', '1', '2024-06-12 22:41:33', '2024-06-12 22:41:33');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (123, 'image/jpeg', '/public/uploads/2024/06/12/1718203477572576.4677491053021.jpeg', 'app/public/uploads/2024/06/12/1718203477572576.4677491053021.jpeg', 'image', 181548, '1718203477572576.4677491053021.jpeg', '1', '2024-06-12 22:44:37', '2024-06-12 22:44:37');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (124, 'image/jpeg', '/public/uploads/2024/06/12/1718204242280222.2059434045187.jpeg', 'app/public/uploads/2024/06/12/1718204242280222.2059434045187.jpeg', 'image', 181548, '1718204242280222.2059434045187.jpeg', '1', '2024-06-12 22:57:22', '2024-06-12 22:57:22');
INSERT INTO `system_file` (`id`, `format`, `url`, `path`, `type`, `size`, `name`, `creator`, `created_at`, `updated_at`) VALUES (125, 'image/jpeg', '/public/uploads/2024/06/12/1718207162872869.3411692471924.jpeg', 'app/public/uploads/2024/06/12/1718207162872869.3411692471924.jpeg', 'image', 749037, '1718207162872869.3411692471924.jpeg', '1', '2024-06-12 23:46:02', '2024-06-12 23:46:02');
COMMIT;

-- ----------------------------
-- Table structure for system_menu
-- ----------------------------
DROP TABLE IF EXISTS `system_menu`;
CREATE TABLE `system_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `icon` varchar(150) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `parent_id` int(11) DEFAULT NULL,
  `sort` int(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_menu
-- ----------------------------
BEGIN;
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (1, '概览', '/dashboard', NULL, 1, NULL, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (2, '系统管理', '/system', NULL, 1, NULL, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (3, '菜单管理', '/system/menu', NULL, 1, 2, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (4, '用户管理', '/system/user', NULL, 1, 2, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (5, '角色管理', '/system/role', NULL, 1, 2, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (6, '文件管理', '/system/file', NULL, 1, 2, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (7, '日志管理', '/system/reqLog', NULL, 1, 2, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (8, '商家管理', '/merchant', NULL, 1, NULL, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (9, '商家列表', '/merchant/merchant', NULL, 1, 8, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (10, '店铺管理', '/shop', NULL, 1, NULL, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (11, '商品管理', '/shop/good', NULL, 1, 10, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (12, '商品分类', '/shop/category', NULL, 1, 10, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (13, '首页轮播图', '/shop/banner', NULL, 1, 10, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (14, '设置', '/setting', NULL, 1, NULL, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (15, '个人资料', '/setting/person', NULL, 1, 14, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (16, '店铺资料', '/setting/shop', NULL, 1, 14, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (17, '订单', '/order', NULL, 1, NULL, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
INSERT INTO `system_menu` (`id`, `name`, `path`, `icon`, `status`, `parent_id`, `sort`, `created_at`, `updated_at`) VALUES (18, '订单列表', '/order/list', NULL, 1, 17, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04');
COMMIT;

-- ----------------------------
-- Table structure for system_permission
-- ----------------------------
DROP TABLE IF EXISTS `system_permission`;
CREATE TABLE `system_permission` (
  `id` varchar(200) NOT NULL,
  `name` varchar(255) NOT NULL,
  `describe` varchar(255) DEFAULT NULL,
  `actions` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_permission
-- ----------------------------
BEGIN;
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('merchant', '商家管理', NULL, 'list,add,delete,detail,update', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('shop-banner', '轮播图', NULL, 'list,add,delete,detail', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('shop-category', '商品分类管理', NULL, 'list,add,delete,detail', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('shop-good', '商品管理', NULL, 'list,add,delete,detail', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('shop-order', '订单', NULL, 'list,add,delete,detail,send', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('system-file', '文件管理', NULL, 'list,add,delete,detail', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('system-log', '日志管理', NULL, 'list', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('system-menu', '菜单管理', NULL, 'list,add,delete,detail,tree', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('system-role', '角色管理', NULL, 'list,add,delete,detail,menuSave,permissionSave', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_permission` (`id`, `name`, `describe`, `actions`, `created_at`, `updated_at`) VALUES ('system-user', '用户管理', NULL, 'list,add,delete,detail,update', '2024-06-12 19:10:05', '2024-06-12 19:10:05');
COMMIT;

-- ----------------------------
-- Table structure for system_req_log
-- ----------------------------
DROP TABLE IF EXISTS `system_req_log`;
CREATE TABLE `system_req_log` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `params` text,
  `action` varchar(255) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `consume_time` bigint(20) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1238 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_req_log
-- ----------------------------
BEGIN;
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1163, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 46, '2024-06-12 21:37:46', '2024-06-12 21:37:46');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1164, '127.0.0.1', 1, '[{\"id\":1,\"name\":\"概览\",\"path\":\"/dashboard\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":2,\"name\":\"系统管理\",\"path\":\"/system\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":3,\"name\":\"菜单管理\",\"path\":\"/system/menu\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":4,\"name\":\"用户管理\",\"path\":\"/system/user\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":5,\"name\":\"角色管理\",\"path\":\"/system/role\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":6,\"name\":\"文件管理\",\"path\":\"/system/file\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":7,\"name\":\"日志管理\",\"path\":\"/system/reqLog\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true},{\"id\":8,\"name\":\"商家管理\",\"path\":\"/merchant\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":9,\"name\":\"商家列表\",\"path\":\"/merchant/merchant\",\"icon\":null,\"parentId\":8,\"sort\":null,\"children\":[]}],\"checked\":true},{\"id\":10,\"name\":\"店铺管理\",\"path\":\"/shop\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":11,\"name\":\"商品管理\",\"path\":\"/shop/good\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":12,\"name\":\"商品分类\",\"path\":\"/shop/category\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":13,\"name\":\"首页轮播图\",\"path\":\"/shop/banner\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true},{\"id\":14,\"name\":\"设置\",\"path\":\"/setting\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":15,\"name\":\"个人资料\",\"path\":\"/setting/person\",\"icon\":null,\"parentId\":14,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":16,\"name\":\"店铺资料\",\"path\":\"/setting/shop\",\"icon\":null,\"parentId\":14,\"sort\":null,\"children\":[]}],\"checked\":true},{\"id\":17,\"name\":\"订单\",\"path\":\"/order\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":18,\"name\":\"订单列表\",\"path\":\"/order/list\",\"icon\":null,\"parentId\":17,\"sort\":null,\"children\":[]}]}]', '/api/system/role/1/menu', 'POST', 200, 12, '2024-06-12 21:38:22', '2024-06-12 21:38:22');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1165, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 49, '2024-06-12 21:40:12', '2024-06-12 21:40:12');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1166, '127.0.0.1', 1, '{\"imageId\":114,\"name\":\"手机\",\"description\":\"手机\",\"status\":1}', '/api/shop/category/save', 'POST', 200, 7, '2024-06-12 21:40:14', '2024-06-12 21:40:14');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1167, '127.0.0.1', 1, '{\"categoryId\":46,\"name\":\"华为Mate60Pro\",\"images\":[{\"id\":114,\"format\":\"image/jpeg\",\"url\":\"/public/uploads/2024/06/12/1718199612676660.8201192799442.jpeg\",\"path\":\"app/public/uploads/2024/06/12/1718199612676660.8201192799442.jpeg\",\"size\":513927,\"name\":\"1718199612676660.8201192799442.jpeg\",\"type\":\"image\",\"creator\":\"1\",\"createdAt\":\"2024-06-12 21:40:12\",\"updatedAt\":\"2024-06-12 21:40:12\",\"isDefault\":true}],\"specs\":[{\"name\":\"白色的\",\"salePrice\":0,\"marketPrice\":0,\"stock\":999}],\"status\":1,\"picId\":114,\"salePrice\":0,\"marketPrice\":0}', '/api/shop/good/save', 'POST', 200, 29, '2024-06-12 21:44:26', '2024-06-12 21:44:26');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1168, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 10, '2024-06-12 21:44:55', '2024-06-12 21:44:55');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1169, '127.0.0.1', 1, '{\"imageId\":115,\"status\":1}', '/api/shop/banner/save', 'POST', 200, 42, '2024-06-12 21:44:58', '2024-06-12 21:44:58');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1170, '127.0.0.1', 1, '{\"imageId\":115,\"sort\":\"123\",\"url\":\"321\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 8, '2024-06-12 21:45:05', '2024-06-12 21:45:05');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1171, '127.0.0.1', 1, '{\"imageId\":115,\"sort\":\"123\",\"url\":\"321\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 16, '2024-06-12 21:45:13', '2024-06-12 21:45:13');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1172, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 21, '2024-06-12 21:45:33', '2024-06-12 21:45:33');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1173, '127.0.0.1', 1, '{\"imageId\":116,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 14, '2024-06-12 21:46:06', '2024-06-12 21:46:06');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1174, '127.0.0.1', 1, '{\"imageId\":116,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 48, '2024-06-12 21:57:34', '2024-06-12 21:57:34');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1175, '127.0.0.1', 1, '[{\"id\":1,\"name\":\"概览\",\"path\":\"/dashboard\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":2,\"name\":\"系统管理\",\"path\":\"/system\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":3,\"name\":\"菜单管理\",\"path\":\"/system/menu\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":4,\"name\":\"用户管理\",\"path\":\"/system/user\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":5,\"name\":\"角色管理\",\"path\":\"/system/role\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":6,\"name\":\"文件管理\",\"path\":\"/system/file\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":7,\"name\":\"日志管理\",\"path\":\"/system/reqLog\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true},{\"id\":8,\"name\":\"商家管理\",\"path\":\"/merchant\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":9,\"name\":\"商家列表\",\"path\":\"/merchant/merchant\",\"icon\":null,\"parentId\":8,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true},{\"id\":10,\"name\":\"店铺管理\",\"path\":\"/shop\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":11,\"name\":\"商品管理\",\"path\":\"/shop/good\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":12,\"name\":\"商品分类\",\"path\":\"/shop/category\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":13,\"name\":\"首页轮播图\",\"path\":\"/shop/banner\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true},{\"id\":14,\"name\":\"设置\",\"path\":\"/setting\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":15,\"name\":\"个人资料\",\"path\":\"/setting/person\",\"icon\":null,\"parentId\":14,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":16,\"name\":\"店铺资料\",\"path\":\"/setting/shop\",\"icon\":null,\"parentId\":14,\"sort\":null,\"children\":[]}],\"checked\":true},{\"id\":17,\"name\":\"订单\",\"path\":\"/order\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":18,\"name\":\"订单列表\",\"path\":\"/order/list\",\"icon\":null,\"parentId\":17,\"sort\":null,\"children\":[]}]}]', '/api/system/role/1/menu', 'POST', 200, 21, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1176, '127.0.0.1', 1, '{\"name\":\"华为官方\",\"status\":1}', '/api/merchant/save', 'POST', 200, 13, '2024-06-12 22:02:13', '2024-06-12 22:02:13');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1177, '127.0.0.1', 1, '[{\"id\":\"merchant\",\"name\":\"商家管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true},{\"action\":\"update\",\"name\":\"修改\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"shop-banner\",\"name\":\"轮播图\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"shop-category\",\"name\":\"商品分类管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"shop-good\",\"name\":\"商品管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"shop-order\",\"name\":\"订单\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":false},{\"action\":\"add\",\"name\":\"添加\",\"checked\":false},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":false},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":false},{\"action\":\"send\",\"name\":\"发货\",\"checked\":false}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":false},{\"id\":\"system-file\",\"name\":\"文件管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"system-log\",\"name\":\"日志管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"system-menu\",\"name\":\"菜单管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true},{\"action\":\"tree\",\"name\":\"树列表\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"system-role\",\"name\":\"角色管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true},{\"action\":\"menuSave\",\"name\":\"保存菜单\",\"checked\":true},{\"action\":\"permissionSave\",\"name\":\"保存权限\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"system-user\",\"name\":\"用户管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true},{\"action\":\"update\",\"name\":\"修改\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true}]', '/api/system/role/1/permission', 'POST', 200, 17, '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1178, '127.0.0.1', 1, '[{\"id\":\"merchant\",\"name\":\"商家管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true},{\"action\":\"update\",\"name\":\"修改\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"shop-banner\",\"name\":\"轮播图\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"shop-category\",\"name\":\"商品分类管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"shop-good\",\"name\":\"商品管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"shop-order\",\"name\":\"订单\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true},{\"action\":\"send\",\"name\":\"发货\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"system-file\",\"name\":\"文件管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":true},{\"action\":\"add\",\"name\":\"添加\",\"checked\":true},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":true},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":true}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":true},{\"id\":\"system-log\",\"name\":\"日志管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":false}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":false},{\"id\":\"system-menu\",\"name\":\"菜单管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":false},{\"action\":\"add\",\"name\":\"添加\",\"checked\":false},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":false},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":false},{\"action\":\"tree\",\"name\":\"树列表\",\"checked\":false}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":false},{\"id\":\"system-role\",\"name\":\"角色管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":false},{\"action\":\"add\",\"name\":\"添加\",\"checked\":false},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":false},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":false},{\"action\":\"menuSave\",\"name\":\"保存菜单\",\"checked\":false},{\"action\":\"permissionSave\",\"name\":\"保存权限\",\"checked\":false}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":false},{\"id\":\"system-user\",\"name\":\"用户管理\",\"describe\":null,\"actions\":[{\"action\":\"list\",\"name\":\"查询\",\"checked\":false},{\"action\":\"add\",\"name\":\"添加\",\"checked\":false},{\"action\":\"delete\",\"name\":\"删除\",\"checked\":false},{\"action\":\"detail\",\"name\":\"详情\",\"checked\":false},{\"action\":\"update\",\"name\":\"修改\",\"checked\":false}],\"createdAt\":\"2024-06-12 19:10:05\",\"updatedAt\":\"2024-06-12 19:10:05\",\"checked\":false}]', '/api/system/role/2/permission', 'POST', 200, 13, '2024-06-12 22:04:04', '2024-06-12 22:04:04');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1179, '127.0.0.1', 1, '[{\"id\":1,\"name\":\"概览\",\"path\":\"/dashboard\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":2,\"name\":\"系统管理\",\"path\":\"/system\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":3,\"name\":\"菜单管理\",\"path\":\"/system/menu\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]},{\"id\":4,\"name\":\"用户管理\",\"path\":\"/system/user\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]},{\"id\":5,\"name\":\"角色管理\",\"path\":\"/system/role\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]},{\"id\":6,\"name\":\"文件管理\",\"path\":\"/system/file\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]},{\"id\":7,\"name\":\"日志管理\",\"path\":\"/system/reqLog\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]}]},{\"id\":8,\"name\":\"商家管理\",\"path\":\"/merchant\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":9,\"name\":\"商家列表\",\"path\":\"/merchant/merchant\",\"icon\":null,\"parentId\":8,\"sort\":null,\"children\":[],\"checked\":true}]},{\"id\":10,\"name\":\"店铺管理\",\"path\":\"/shop\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":11,\"name\":\"商品管理\",\"path\":\"/shop/good\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":12,\"name\":\"商品分类\",\"path\":\"/shop/category\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":13,\"name\":\"首页轮播图\",\"path\":\"/shop/banner\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true},{\"id\":14,\"name\":\"设置\",\"path\":\"/setting\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":15,\"name\":\"个人资料\",\"path\":\"/setting/person\",\"icon\":null,\"parentId\":14,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":16,\"name\":\"店铺资料\",\"path\":\"/setting/shop\",\"icon\":null,\"parentId\":14,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true},{\"id\":17,\"name\":\"订单\",\"path\":\"/order\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":18,\"name\":\"订单列表\",\"path\":\"/order/list\",\"icon\":null,\"parentId\":17,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true}]', '/api/system/role/2/menu', 'POST', 200, 12, '2024-06-12 22:04:22', '2024-06-12 22:04:22');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1180, '127.0.0.1', 1, '[{\"id\":1,\"name\":\"概览\",\"path\":\"/dashboard\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":2,\"name\":\"系统管理\",\"path\":\"/system\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":3,\"name\":\"菜单管理\",\"path\":\"/system/menu\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]},{\"id\":4,\"name\":\"用户管理\",\"path\":\"/system/user\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]},{\"id\":5,\"name\":\"角色管理\",\"path\":\"/system/role\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]},{\"id\":6,\"name\":\"文件管理\",\"path\":\"/system/file\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]},{\"id\":7,\"name\":\"日志管理\",\"path\":\"/system/reqLog\",\"icon\":null,\"parentId\":2,\"sort\":null,\"children\":[]}]},{\"id\":8,\"name\":\"商家管理\",\"path\":\"/merchant\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":9,\"name\":\"商家列表\",\"path\":\"/merchant/merchant\",\"icon\":null,\"parentId\":8,\"sort\":null,\"children\":[],\"checked\":true}]},{\"id\":10,\"name\":\"店铺管理\",\"path\":\"/shop\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":11,\"name\":\"商品管理\",\"path\":\"/shop/good\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":12,\"name\":\"商品分类\",\"path\":\"/shop/category\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":13,\"name\":\"首页轮播图\",\"path\":\"/shop/banner\",\"icon\":null,\"parentId\":10,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true},{\"id\":14,\"name\":\"设置\",\"path\":\"/setting\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":15,\"name\":\"个人资料\",\"path\":\"/setting/person\",\"icon\":null,\"parentId\":14,\"sort\":null,\"children\":[],\"checked\":true},{\"id\":16,\"name\":\"店铺资料\",\"path\":\"/setting/shop\",\"icon\":null,\"parentId\":14,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true},{\"id\":17,\"name\":\"订单\",\"path\":\"/order\",\"icon\":null,\"parentId\":null,\"sort\":null,\"children\":[{\"id\":18,\"name\":\"订单列表\",\"path\":\"/order/list\",\"icon\":null,\"parentId\":17,\"sort\":null,\"children\":[],\"checked\":true}],\"checked\":true}]', '/api/system/role/2/menu', 'POST', 200, 13, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1181, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 13, '2024-06-12 22:05:35', '2024-06-12 22:05:35');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1182, '127.0.0.1', 1, '{\"imageId\":117,\"sort\":\"1\",\"url\":\"1\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 18, '2024-06-12 22:05:39', '2024-06-12 22:05:39');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1183, '127.0.0.1', 1, '{\"imageId\":117,\"sort\":\"1\",\"url\":\"1\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 25, '2024-06-12 22:06:38', '2024-06-12 22:06:38');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1184, '127.0.0.1', 1, '{\"imageId\":117,\"sort\":\"1\",\"url\":\"1\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 48, '2024-06-12 22:07:02', '2024-06-12 22:07:02');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1185, '127.0.0.1', 1, '{\"imageId\":117,\"sort\":\"1\",\"url\":\"1\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 19, '2024-06-12 22:14:01', '2024-06-12 22:14:01');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1186, '127.0.0.1', 1, '{\"imageId\":117,\"sort\":\"1\",\"url\":\"1\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 38, '2024-06-12 22:14:15', '2024-06-12 22:14:15');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1187, '127.0.0.1', NULL, '{\"name\":\"tcy\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 91, '2024-06-12 22:15:02', '2024-06-12 22:15:02');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1188, '127.0.0.1', 2, '{}', '/api/system/file/upload', 'POST', 200, 11, '2024-06-12 22:15:11', '2024-06-12 22:15:11');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1189, '127.0.0.1', 2, '{\"imageId\":118,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 20, '2024-06-12 22:15:21', '2024-06-12 22:15:21');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1190, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 36, '2024-06-12 22:16:58', '2024-06-12 22:16:58');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1191, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 14, '2024-06-12 22:18:14', '2024-06-12 22:18:14');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1192, '127.0.0.1', 1, '{\"imageId\":119,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 18, '2024-06-12 22:18:23', '2024-06-12 22:18:23');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1193, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 24, '2024-06-12 22:19:02', '2024-06-12 22:19:02');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1194, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 19, '2024-06-12 22:19:13', '2024-06-12 22:19:13');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1195, '127.0.0.1', 1, '{\"imageId\":120,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 16, '2024-06-12 22:19:18', '2024-06-12 22:19:18');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1196, '127.0.0.1', 1, '{\"imageId\":120,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 37, '2024-06-12 22:20:13', '2024-06-12 22:20:13');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1197, '127.0.0.1', 1, '{\"imageId\":120,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 45, '2024-06-12 22:21:33', '2024-06-12 22:21:33');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1198, '127.0.0.1', 1, '{\"imageId\":120,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 49, '2024-06-12 22:22:13', '2024-06-12 22:22:13');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1199, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 62, '2024-06-12 22:25:04', '2024-06-12 22:25:04');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1200, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 44, '2024-06-12 22:28:01', '2024-06-12 22:28:01');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1201, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 53, '2024-06-12 22:30:29', '2024-06-12 22:30:29');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1202, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 56, '2024-06-12 22:32:09', '2024-06-12 22:32:09');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1203, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 28, '2024-06-12 22:33:09', '2024-06-12 22:33:09');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1204, '127.0.0.1', 1, '{\"imageId\":121,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 34, '2024-06-12 22:33:22', '2024-06-12 22:33:22');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1205, '127.0.0.1', 1, '{\"imageId\":121,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 44, '2024-06-12 22:34:26', '2024-06-12 22:34:26');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1206, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 50, '2024-06-12 22:34:43', '2024-06-12 22:34:43');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1207, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 72, '2024-06-12 22:36:39', '2024-06-12 22:36:39');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1208, '127.0.0.1', NULL, '{\"name\":\"admin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 58, '2024-06-12 22:40:56', '2024-06-12 22:40:56');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1209, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 41, '2024-06-12 22:41:33', '2024-06-12 22:41:33');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1210, '127.0.0.1', 1, '{\"imageId\":122,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 34, '2024-06-12 22:41:43', '2024-06-12 22:41:43');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1211, '127.0.0.1', 1, '{\"imageId\":122,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 78, '2024-06-12 22:42:21', '2024-06-12 22:42:21');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1212, '127.0.0.1', 1, '{\"imageId\":122,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 62, '2024-06-12 22:43:25', '2024-06-12 22:43:25');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1213, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 44, '2024-06-12 22:44:37', '2024-06-12 22:44:37');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1214, '127.0.0.1', 1, '{\"imageId\":123,\"sort\":\"1\",\"url\":\"http://www.baidu.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 15, '2024-06-12 22:44:51', '2024-06-12 22:44:51');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1215, '127.0.0.1', 1, '{\"name\":\"手机\",\"description\":\"手机\",\"status\":1,\"createdAt\":\"2024-06-12 21:40:14\",\"id\":46,\"merchantId\":null,\"imageUrl\":\"/public/uploads/2024/06/12/1718199612676660.8201192799442.jpeg\",\"parent\":null}', '/api/shop/category/save', 'POST', 200, 13, '2024-06-12 22:50:56', '2024-06-12 22:50:56');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1216, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 37, '2024-06-12 22:57:22', '2024-06-12 22:57:22');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1217, '127.0.0.1', 1, '{\"imageId\":124,\"parentId\":46,\"name\":\"华为\",\"status\":1}', '/api/shop/category/save', 'POST', 200, 8, '2024-06-12 22:57:24', '2024-06-12 22:57:24');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1218, '127.0.0.1', 1, '{\"name\":\"手机\",\"description\":\"手机\",\"status\":1,\"createdAt\":\"2024-06-12 22:50:56\",\"id\":46,\"merchantId\":1,\"imageUrl\":\"/public/uploads/2024/06/12/1718199612676660.8201192799442.jpeg\",\"parent\":null}', '/api/shop/category/save', 'POST', 200, 7, '2024-06-12 22:59:02', '2024-06-12 22:59:02');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1219, '127.0.0.1', 1, '{\"categoryId\":47,\"name\":\"华为Mate60Pro\",\"images\":[{\"id\":115,\"format\":\"image/jpeg\",\"url\":\"/public/uploads/2024/06/12/1718199895732150.9327417864763.jpeg\",\"path\":\"app/public/uploads/2024/06/12/1718199895732150.9327417864763.jpeg\",\"size\":181548,\"name\":\"1718199895732150.9327417864763.jpeg\",\"type\":\"image\",\"creator\":\"1\",\"createdAt\":\"2024-06-12 21:44:55\",\"updatedAt\":\"2024-06-12 21:44:55\",\"isDefault\":true}],\"specs\":[{\"name\":\"白色\",\"salePrice\":0,\"marketPrice\":0,\"stock\":999}],\"status\":1,\"picId\":115,\"salePrice\":0,\"marketPrice\":0,\"merchantId\":2}', '/api/shop/good/save', 'POST', 500, 64, '2024-06-12 23:16:54', '2024-06-12 23:16:54');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1220, '127.0.0.1', 1, '{}', '/api/system/file/upload', 'POST', 200, 19, '2024-06-12 23:46:02', '2024-06-12 23:46:02');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1221, '127.0.0.1', 1, '{\"imageId\":125,\"sort\":\"2\",\"url\":\"http://www.jd.com\",\"status\":1}', '/api/shop/banner/save', 'POST', 200, 11, '2024-06-12 23:46:14', '2024-06-12 23:46:14');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1222, '::1', NULL, '{\"name\":\"bin\",\"username\":\"bin\",\"email\":\"abin@163.com\",\"password\":\"123456\"}', '/api/system/user/regist', 'POST', 200, 39, '2024-06-14 19:29:59', '2024-06-14 19:29:59');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1223, '::1', NULL, '{\"name\":\"bin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 38, '2024-06-14 19:30:16', '2024-06-14 19:30:16');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1224, '::1', 3, '{\"name\":\"bin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 26, '2024-06-14 19:33:21', '2024-06-14 19:33:21');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1225, '::1', 3, '{\"name\":\"bin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 15, '2024-06-14 19:33:43', '2024-06-14 19:33:43');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1226, '::1', 3, '{\"name\":\"bin\",\"password\":\"123456\"}', '/api/system/user/login', 'POST', 200, 18, '2024-06-14 19:36:13', '2024-06-14 19:36:13');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1227, '::1', 3, '{\"goodId\":19,\"userId\":3}', '/api/member/fav/save', 'POST', 200, 8, '2024-06-14 19:42:43', '2024-06-14 19:42:43');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1228, '::1', 3, '{\"name\":\"斌\",\"tel\":\"18312341234\",\"city\":\"北京市\",\"county\":\"东城区\",\"country\":\"\",\"province\":\"北京市\",\"areaCode\":\"110101\",\"isDefault\":true,\"postalCode\":\"123123\",\"addressDetail\":\"八维\",\"userId\":3}', '/api/member/address/save', 'POST', 200, 23, '2024-06-14 20:22:08', '2024-06-14 20:22:08');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1229, '::1', 3, '{\"addressId\":1,\"merchantId\":1,\"remark\":\"\",\"goodList\":[{\"id\":19,\"qty\":3,\"goodSpecId\":11}]}', '/api/member/order/save', 'POST', 500, 32, '2024-06-14 20:22:14', '2024-06-14 20:22:14');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1230, '::1', 3, '{\"addressId\":1,\"merchantId\":1,\"remark\":\"\",\"goodList\":[{\"id\":19,\"qty\":3,\"goodSpecId\":11}]}', '/api/member/order/save', 'POST', 500, 29, '2024-06-14 20:23:33', '2024-06-14 20:23:33');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1231, '::1', 3, '{\"addressId\":1,\"merchantId\":1,\"remark\":\"\",\"goodList\":[{\"id\":19,\"qty\":3,\"goodSpecId\":11}]}', '/api/member/order/save', 'POST', 500, 53, '2024-06-14 20:24:40', '2024-06-14 20:24:40');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1232, '::1', 3, '{\"addressId\":1,\"merchantId\":1,\"remark\":\"\",\"goodList\":[{\"id\":19,\"qty\":3,\"goodSpecId\":11}]}', '/api/member/order/save', 'POST', 500, 25, '2024-06-14 20:24:46', '2024-06-14 20:24:46');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1233, '::1', 3, '{\"addressId\":1,\"merchantId\":1,\"remark\":\"\",\"goodList\":[{\"id\":19,\"qty\":3,\"goodSpecId\":11}]}', '/api/member/order/save', 'POST', 500, 47, '2024-06-14 20:25:46', '2024-06-14 20:25:46');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1234, '::1', 3, '{\"addressId\":1,\"merchantId\":1,\"remark\":\"\",\"goodList\":[{\"id\":19,\"qty\":3,\"goodSpecId\":11}]}', '/api/member/order/save', 'POST', 500, 44, '2024-06-14 20:27:14', '2024-06-14 20:27:14');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1235, '::1', 3, '{\"addressId\":1,\"merchantId\":1,\"remark\":\"\",\"goodList\":[{\"id\":19,\"qty\":3,\"goodSpecId\":11}]}', '/api/member/order/save', 'POST', 500, 50, '2024-06-14 20:28:52', '2024-06-14 20:28:52');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1236, '::1', 3, '{\"addressId\":1,\"merchantId\":1,\"remark\":\"\",\"goodList\":[{\"id\":19,\"qty\":3,\"goodSpecId\":11}]}', '/api/member/order/save', 'POST', 200, 49, '2024-06-14 20:30:18', '2024-06-14 20:30:18');
INSERT INTO `system_req_log` (`id`, `ip`, `user_id`, `params`, `action`, `method`, `status`, `consume_time`, `created_at`, `updated_at`) VALUES (1237, '::1', 3, '{}', '/api/member/order/pay/1', 'POST', 200, 8, '2024-06-14 20:30:26', '2024-06-14 20:30:26');
COMMIT;

-- ----------------------------
-- Table structure for system_role
-- ----------------------------
DROP TABLE IF EXISTS `system_role`;
CREATE TABLE `system_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `describe` varchar(200) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_role
-- ----------------------------
BEGIN;
INSERT INTO `system_role` (`id`, `name`, `describe`, `status`, `created_at`, `updated_at`) VALUES (1, '管理员', NULL, 1, '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_role` (`id`, `name`, `describe`, `status`, `created_at`, `updated_at`) VALUES (2, '商家', NULL, 1, '2024-06-12 19:10:05', '2024-06-12 19:10:05');
INSERT INTO `system_role` (`id`, `name`, `describe`, `status`, `created_at`, `updated_at`) VALUES (3, '用户', NULL, 1, '2024-06-12 19:10:05', '2024-06-12 19:10:05');
COMMIT;

-- ----------------------------
-- Table structure for system_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `system_role_menu`;
CREATE TABLE `system_role_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (36, 1, 1, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (37, 1, 2, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (38, 1, 3, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (39, 1, 4, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (40, 1, 5, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (41, 1, 6, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (42, 1, 7, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (43, 1, 8, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (44, 1, 9, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (45, 1, 10, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (46, 1, 11, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (47, 1, 12, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (48, 1, 13, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (49, 1, 14, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (50, 1, 15, '2024-06-12 22:00:42', '2024-06-12 22:00:42');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (62, 2, 1, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (63, 2, 9, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (64, 2, 10, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (65, 2, 11, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (66, 2, 12, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (67, 2, 13, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (68, 2, 14, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (69, 2, 15, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (70, 2, 16, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (71, 2, 17, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `created_at`, `updated_at`) VALUES (72, 2, 18, '2024-06-12 22:04:27', '2024-06-12 22:04:27');
COMMIT;

-- ----------------------------
-- Table structure for system_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `system_role_permission`;
CREATE TABLE `system_role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL,
  `permission_id` varchar(200) DEFAULT NULL,
  `actions` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (12, 1, 'merchant', 'list,add,delete,detail,update', '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (13, 1, 'shop-banner', 'list,add,delete,detail', '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (14, 1, 'shop-category', 'list,add,delete,detail', '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (15, 1, 'shop-good', 'list,add,delete,detail', '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (16, 1, 'system-file', 'list,add,delete,detail', '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (17, 1, 'system-log', 'list', '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (18, 1, 'system-menu', 'list,add,delete,detail,tree', '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (19, 1, 'system-role', 'list,add,delete,detail,menuSave,permissionSave', '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (20, 1, 'system-user', 'list,add,delete,detail,update', '2024-06-12 22:03:48', '2024-06-12 22:03:48');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (21, 2, 'merchant', 'list,add,delete,detail,update', '2024-06-12 22:04:04', '2024-06-12 22:04:04');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (22, 2, 'shop-banner', 'list,add,delete,detail', '2024-06-12 22:04:04', '2024-06-12 22:04:04');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (23, 2, 'shop-category', 'list,add,delete,detail', '2024-06-12 22:04:04', '2024-06-12 22:04:04');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (24, 2, 'shop-good', 'list,add,delete,detail', '2024-06-12 22:04:04', '2024-06-12 22:04:04');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (25, 2, 'shop-order', 'list,add,delete,detail,send', '2024-06-12 22:04:04', '2024-06-12 22:04:04');
INSERT INTO `system_role_permission` (`id`, `role_id`, `permission_id`, `actions`, `created_at`, `updated_at`) VALUES (26, 2, 'system-file', 'list,add,delete,detail', '2024-06-12 22:04:04', '2024-06-12 22:04:04');
COMMIT;

-- ----------------------------
-- Table structure for system_user
-- ----------------------------
DROP TABLE IF EXISTS `system_user`;
CREATE TABLE `system_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `email` varchar(50) DEFAULT NULL,
  `password` varchar(32) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `sex` int(1) DEFAULT '1',
  `avatar_id` int(11) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '用户状态： 0:禁用, 1:启用,',
  `last_login_time` int(11) DEFAULT NULL,
  `last_login_ip` varchar(100) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `department` varchar(100) DEFAULT NULL,
  `unionid` varchar(100) DEFAULT NULL,
  `openid` varchar(100) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `type` int(3) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of system_user
-- ----------------------------
BEGIN;
INSERT INTO `system_user` (`id`, `username`, `email`, `password`, `name`, `sex`, `avatar_id`, `phone`, `role_id`, `status`, `last_login_time`, `last_login_ip`, `company`, `department`, `unionid`, `openid`, `created_at`, `updated_at`, `type`) VALUES (1, 'admin', NULL, 'e10adc3949ba59abbe56e057f20f883e', '超级管理员', 1, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04', 1);
INSERT INTO `system_user` (`id`, `username`, `email`, `password`, `name`, `sex`, `avatar_id`, `phone`, `role_id`, `status`, `last_login_time`, `last_login_ip`, `company`, `department`, `unionid`, `openid`, `created_at`, `updated_at`, `type`) VALUES (2, 'tcy', NULL, 'e10adc3949ba59abbe56e057f20f883e', '商家', 1, NULL, NULL, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-12 19:10:04', '2024-06-12 19:10:04', 2);
INSERT INTO `system_user` (`id`, `username`, `email`, `password`, `name`, `sex`, `avatar_id`, `phone`, `role_id`, `status`, `last_login_time`, `last_login_ip`, `company`, `department`, `unionid`, `openid`, `created_at`, `updated_at`, `type`) VALUES (3, 'bin', 'abin@163.com', 'e10adc3949ba59abbe56e057f20f883e', 'bin', 1, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-14 19:29:59', '2024-06-14 19:29:59', NULL);
COMMIT;

-- ----------------------------
-- Table structure for user_address
-- ----------------------------
DROP TABLE IF EXISTS `user_address`;
CREATE TABLE `user_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `province` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `county` varchar(255) DEFAULT NULL,
  `township` varchar(255) DEFAULT NULL,
  `address_detail` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `area_code` varchar(255) DEFAULT NULL,
  `postal_code` varchar(255) DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT '0',
  `longitude` double DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_address
-- ----------------------------
BEGIN;
INSERT INTO `user_address` (`id`, `province`, `city`, `county`, `township`, `address_detail`, `name`, `tel`, `area_code`, `postal_code`, `is_default`, `longitude`, `latitude`, `user_id`, `created_at`, `updated_at`) VALUES (1, '北京市', '北京市', '东城区', NULL, '八维', '斌', '18312341234', '110101', '123123', 1, NULL, NULL, 3, '2024-06-14 20:22:08', '2024-06-14 20:22:08');
COMMIT;

-- ----------------------------
-- Table structure for user_fav
-- ----------------------------
DROP TABLE IF EXISTS `user_fav`;
CREATE TABLE `user_fav` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `good_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_fav
-- ----------------------------
BEGIN;
INSERT INTO `user_fav` (`id`, `good_id`, `user_id`, `created_at`, `updated_at`) VALUES (1, 19, 3, '2024-06-14 19:42:43', '2024-06-14 19:42:43');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
